<?php
use think\Db;

/**
 * @Author  lingyun
 * @Desc    获取城市列表
 *          切换门店时选择城市列表
 *          获取有门店的城市列表
 * 2018-03-29
 */
function get_city(){
    $city_key = db('store')->where(['status'=>1,'is_deleted'=>0])->group('city_key')->column('city_key');
    $where = [
        'status'=>1,
        'is_deleted'=>0,
        'key'=>['in',$city_key]
    ];

    $city  = db('city')->where($where)->select();
    return $city;
}

/**
 * @Author  lingyun
 * @Desc    选择门店列表
 * @param $city_key     城市列表
 *          切换门店时查询选中城市的门店列表
 * 2018-03-29
 */
function get_store($city_key){
    $city = db('city')->where('key',$city_key)->find();
    cookie('city',$city['value'],15552000);
    cookie('city_key',$city['key'],15552000);
    cookie('city_code',$city['code'],15552000);
    $store = db('store')->where(['city_key'=>$city_key,'status'=>1,'is_deleted'=>0])->field('id,title,addtime')->select();
    return $store;
}

/**
 * @Author  lingyun
 * @Desc    获取顶部导航栏
 * 2018-03-29
 */
function get_top_category(){
    $list = db('goods_category')->where(['is_exp'=>0,'status'=>1,'is_deleted'=>0])->order('dis_order desc')->select();
    return $list;
}

/**
 * @Author  lingyun
 * @Desc    获取扩展分类
 * 2018-03-29
 */
function get_exp_category(){
    $list = db('goods_category')->where(['is_exp'=>1,'status'=>1,'is_deleted'=>0])->order('dis_order desc')->select();
    return $list;
}

function isMobile()
{
    // 如果有HTTP_X_WAP_PROFILE则一定是移动设备
    if (isset ($_SERVER['HTTP_X_WAP_PROFILE']))
    {
        return true;
    }
    // 如果via信息含有wap则一定是移动设备,部分服务商会屏蔽该信息
    if (isset ($_SERVER['HTTP_VIA']))
    {
        // 找不到为flase,否则为true
        return stristr($_SERVER['HTTP_VIA'], "wap") ? true : false;
    }
    // 脑残法，判断手机发送的客户端标志,兼容性有待提高
    if (isset ($_SERVER['HTTP_USER_AGENT']))
    {
        $clientkeywords = array ('nokia',
            'sony',
            'ericsson',
            'mot',
            'samsung',
            'htc',
            'sgh',
            'lg',
            'sharp',
            'sie-',
            'philips',
            'panasonic',
            'alcatel',
            'lenovo',
            'iphone',
            'ipod',
            'blackberry',
            'meizu',
            'android',
            'netfront',
            'symbian',
            'ucweb',
            'windowsce',
            'palm',
            'operamini',
            'operamobi',
            'openwave',
            'nexusone',
            'cldc',
            'midp',
            'wap',
            'mobile'
        );
        // 从HTTP_USER_AGENT中查找手机浏览器的关键字
        if (preg_match("/(" . implode('|', $clientkeywords) . ")/i", strtolower($_SERVER['HTTP_USER_AGENT'])))
        {
            return true;
        }
    }
    // 协议法，因为有可能不准确，放到最后判断
    if (isset ($_SERVER['HTTP_ACCEPT']))
    {
        // 如果只支持wml并且不支持html那一定是移动设备
        // 如果支持wml和html但是wml在html之前则是移动设备
        if ((strpos($_SERVER['HTTP_ACCEPT'], 'vnd.wap.wml') !== false) && (strpos($_SERVER['HTTP_ACCEPT'], 'text/html') === false || (strpos($_SERVER['HTTP_ACCEPT'], 'vnd.wap.wml') < strpos($_SERVER['HTTP_ACCEPT'], 'text/html'))))
        {
            return true;
        }
    }
    return false;
}




